Subquery issue with null records in left table

welcome to shbcf.ru